SUPPORT / SAMPLES & SAS NOTES
Problem Note 47790: In-database publishing macros return "Syntax error, expecting one of the following.." with certain Teradata databases
 |  |  |  |
In SAS® Model Manager, the following error might occur when publishing a scoring function to the Teradata 13.1 database server:
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT.
The error occurs because the query to get the platform of the server returns incorrect values.
There is no workaround for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Model Manager | Microsoft® Windows® for x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional 32 bit | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| HP-UX IPF | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Linux for x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Solaris for x64 | 2.3 | 3.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||